-
Re: COUNTIF, Cross Sheet, Multiple Contacts
Looks like you might just be missing a comma before your HAS function: =COUNTIF({Internal Comms Intake Range 1}, HAS(@cell, "Amy Merck"))1 · -
Re: COUNTIF, Cross Sheet, Multiple Contacts
Are you putting the formula in a column of type Contact List? If so, that column is expecting a contact to be entered and won't show a value for your COUNTIF formula. You'll need to either put your f…1 · -
Re: Adding # of days with in a date range
Looks to me like you're just missing a command in your SUMIFS formula before the <=. This should work =SUMIFS({2021 Sioux City Utility OSHA 300 Form Range 18}, {2021 Sioux City Utility OSHA 300 Fo…1 · -
Re: API Access to Column Formulas
That's a real bummer, sorry. Might be worth reaching out to your account rep to see if they can't get engineering/high-level support to look into it.1 · -
Re: API Access to Column Formulas
Yes, I was able to make a modification using this: I can verify this updated the column formula immediately.1 ·